Continous Collections
Continous collection program is getting erred out with below error message 09-OCT 21:00:11 : Staging tables' data is not collected. Please submit the request - Planning ODS LOAD. I tried to run the standard collection program but that also got erred out with the same message. Both these program 'er running sucessfully till y day. What could be the reason
Complete log
Below is the complete log from ODS load program
Bad sqls for this session
------------------------------------------------------------
************************************************************
09-OCT 21:33:01 : Sent status 14 to the monitor.
09-OCT 21:33:01 : Procedure MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY started.
09-OCT 21:33:01 : The sql statement is INSERT INTO ITEM_CATEGORIES_TST SELECT * from MSC_ITEM_CATEGORIES WHERE sr_instance_id = 21 AND organization_id not IN (207)
09-OCT 21:33:13 : Procedure alter_temp_table started.
09-OCT 21:33:13 : MSC_CL_EXCHANGE_PARTTBL.Initialize successful
P_table_name = MSC_ITEM_CATEGORIES
09-OCT 21:33:52 : ERROR
09-OCT 21:33:52 : Unique index violated - ITEM_CATEGORIES_U1_TST
09-OCT 21:33:53 : ORA-12801: error signaled in parallel query server P003
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
09-OCT 21:33:53 : ======= Below records violate the unique constraint =======
09-OCT 21:33:57 : ORGANIZATION_ID 207 / SR_INSTANCE_ID 21 / INVENTORY_ITEM_ID 148085 / CATEGORY_SET_ID 2 / SR_CATEGORY_ID 1396
09-OCT 21:33:57 : ORGANIZATION_ID 207 / SR_INSTANCE_ID 21 / INVENTORY_ITEM_ID 148085 / CATEGORY_SET_ID 6 / SR_CATEGORY_ID 1
09-OCT 21:33:57 : ORGANIZATION_ID 207 / SR_INSTANCE_ID 21 / INVENTORY_ITEM_ID 148085 / CATEGORY_SET_ID 162 / SR_CATEGORY_ID 2257
09-OCT 21:33:57 : ===========================================================
09-OCT 21:33:57 : <